/**
 * Copyright 2014,Peak Tai 台俊峰(taijunfeng_it@sina.com).
 * 
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at
 * 
 * 		http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 */

package com.cenluan.me.call;

import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Page;

public class MyCallService {

	static Page<Call> paginate(int pn, String userId) {
		StringBuilder sql = new StringBuilder();
		sql.append(" from t_call ");
		sql.append(" where toUserId=? ");
		sql.append(" order by 'read' asc,createTime desc ");
		return Call.dao.paginate(pn, 20, "select *", sql.toString(), userId);
	}

	/**
	 * 标记所有的为已阅读
	 * 
	 * @param userId
	 */
	static void markAllAsRead(String userId) {
		Db.update("update t_call set 'read'=1 where toUserId=?", userId);
	}
}
